home
***
CD-ROM
|
disk
|
FTP
|
other
***
search
/
Libris Britannia 4
/
science library(b).zip
/
science library(b)
/
UTILITIE
/
CPU_MEMO
/
2363.ZIP
/
GRAPHICS.DOC
< prev
next >
Wrap
Text File
|
1990-11-11
|
4KB
|
108 lines
GRAPHICS 1.0 Documentation
(C) Copyright 1987 Biologic Company; ALL RIGHTS RESERVED
Biologic Company Represented in the U.K. by
P.O. Box 1267 The Thompson Partnership
Manassas, Virginia 10, Church Croft,
22110 Bramshall,
703-368-2949 UTTOXETER,
Staffs ST14 5DE
INTRODUCTION
The set of macro routines in graphics.wk1 provide a way to enter IBM standard
graphics characters in Lotus 1-2-3 worksheets, and use them in any combination
to create graphics such as boxes, diagrams, and charts. The macros have been
designed so that characters can be created easily and quickly, without
disrupting the normal operation of 1-2-3.
Requirements
Graphics.wk1 requires Lotus 1-2-3 Release 2.
INSTALLATION
To display graphics characters in Lotus 1-2-3 you must use a driver set with
the text display installed as "Universal Test Display -ASCII- No LICS". It is
not necessary to install a graphics display or change it if one has been
installed.
Procedure
Step 1. Start the Lotus 1-2-3 Install program as described in the 1-2-3
manual.
Step 2. Select "Advanced Options".
Step 3. Select "Modify Current Driver Set".
Step 4. Select "Text Display".
Step 5. Select "Universal Text Display -ASCII- No LICS".
Step 6. Select "Return to menu".
Step 7. Select "Save Changes".
Step 8. Press ENTER to save this driver set as "123.set" or enter a new
name if you'd like to keep your original driver set.
(note: If your new driver set is not named "123.set" you should specify it
on the command line when starting 1-2-3 (i.e., 123 graphics))
Step 9. Exit the Install program.
USING GRAPHICS.WK1
The 4 macros contained in graphics.wk1 -- \Z, \X, \C, and \V -- are all used in
the same way. When invoked, each displays a list of characters. Choose a
character by pressing its corresponding number and ENTER, and either select a
range to fill with the character or press ENTER to put the character in the
current cell only. Each macro displays a different set of characters; select
\Z for single line graphics, \X for double line, \C for single line and double
line combinations, and \V for block symbols.
To use any of these macros in a new worksheet, retrieve the file graphics.wk1
first. Leave the routines in the upper-left hand corner, or move them anywhere
you wish, but be sure not to insert any rows or columns within them. If you
move the macros by inserting rows or columns, recalculate your worksheet.
Example
To draw a box with single lines:
Step 1. Start a new worksheet by retrieving graphics.wk1.
Step 2. Move the cellpointer to an open area of the worksheet.
Step 3. Press Alt-Z, 3, and ENTER. Press ENTER again to put an upper-
left corner in the current cell.
Step 4. Move the cellpointer 1 cell to the right. Press Alt-Z, 1, and
ENTER. Move the cellpointer a few cells to the right. Press ENTER to put
a horizontal line in each of the marked cells.
Step 5. Continue by selecting appropriate characters, marking the range
to fill, and pressing ENTER.
NOTES
o The recalculation method should be set to Manual when using Graphics.wk1.
o The macros in graphics.wk1 position characters within a cell using the
@cell() function. If you adjust the width of a column that has graphics
characters, they will be repositioned and their length adjusted when the
worksheet is recalculated. Although you can use the Range Value command
to convert the formulas to actual character strings, they will not be
adjusted when column width is changed. Do not convert the character
formulas to strings if you intend to print the worksheet using Gprint.
o Graphics.wk1 can be incorporated into a worksheet at any location using
the File Combine command. After you have used File Combine Text to read
graphics.wk1, put the cellpointer at the cell with the label "\x" and use
the Range Name Label Right command to turn all of the labels in that
column into range names. Then recalculate your worksheet.
o All range names begin with "gr" to limit conflicts with other range names
in your worksheet.